Overview
Brought to you by YData
Dataset statistics
| Number of variables | 11 |
|---|---|
| Number of observations | 1000 |
| Missing cells | 549 |
| Missing cells (%) | 5.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 86.1 KiB |
| Average record size in memory | 88.1 B |
Variable types
| Numeric | 6 |
|---|---|
| Categorical | 5 |
Trip_Distance_km is highly overall correlated with Trip_Price | High correlation |
Trip_Price is highly overall correlated with Trip_Distance_km | High correlation |
Trip_Distance_km has 50 (5.0%) missing values | Missing |
Time_of_Day has 50 (5.0%) missing values | Missing |
Day_of_Week has 50 (5.0%) missing values | Missing |
Passenger_Count has 50 (5.0%) missing values | Missing |
Traffic_Conditions has 50 (5.0%) missing values | Missing |
Weather has 50 (5.0%) missing values | Missing |
Base_Fare has 50 (5.0%) missing values | Missing |
Per_Km_Rate has 50 (5.0%) missing values | Missing |
Per_Minute_Rate has 50 (5.0%) missing values | Missing |
Trip_Duration_Minutes has 50 (5.0%) missing values | Missing |
Trip_Price has 49 (4.9%) missing values | Missing |
Reproduction
| Analysis started | 2025-02-13 22:02:12.027122 |
|---|---|
| Analysis finished | 2025-02-13 22:02:14.316445 |
| Duration | 2.29 seconds |
| Software version | ydata-profiling vv4.12.2 |
| Download configuration | config.json |
Variables
Trip_Distance_km
Real number (ℝ)
High correlation Missing
| Distinct | 867 |
|---|---|
| Distinct (%) | 91.3% |
| Missing | 50 |
| Missing (%) | 5.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 27.070547 |
| Minimum | 1.23 |
|---|---|
| Maximum | 146.06705 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 7.9 KiB |
Quantile statistics
| Minimum | 1.23 |
|---|---|
| 5-th percentile | 3.2245 |
| Q1 | 12.6325 |
| median | 25.83 |
| Q3 | 38.405 |
| 95-th percentile | 48.3065 |
| Maximum | 146.06705 |
| Range | 144.83705 |
| Interquartile range (IQR) | 25.7725 |
Descriptive statistics
| Standard deviation | 19.9053 |
|---|---|
| Coefficient of variation (CV) | 0.73531207 |
| Kurtosis | 9.6532589 |
| Mean | 27.070547 |
| Median Absolute Deviation (MAD) | 12.965 |
| Skewness | 2.23601 |
| Sum | 25717.02 |
| Variance | 396.22096 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 3 | 3 | 0.3% |
| 9.91 | 3 | 0.3% |
| 32.04 | 3 | 0.3% |
| 10.14 | 3 | 0.3% |
| 25.63 | 3 | 0.3% |
| 3.22 | 3 | 0.3% |
| 31.29 | 3 | 0.3% |
| 13.64 | 3 | 0.3% |
| 29.95 | 2 | 0.2% |
| 46.9 | 2 | 0.2% |
| Other values (857) | 922 | |
| (Missing) | 50 | 5.0% |
| Value | Count | Frequency (%) |
| 1.23 | 1 | |
| 1.25 | 1 | |
| 1.27 | 1 | |
| 1.34 | 1 | |
| 1.45 | 1 | |
| 1.53 | 1 | |
| 1.54 | 1 | |
| 1.56 | 1 | |
| 1.64 | 2 | |
| 1.71 | 2 |
| Value | Count | Frequency (%) |
| 146.0670472 | 1 | |
| 145.7470599 | 1 | |
| 139.4765146 | 1 | |
| 139.0622302 | 1 | |
| 138.7638872 | 1 | |
| 138.0983279 | 1 | |
| 130.8090013 | 1 | |
| 126.5476283 | 1 | |
| 122.820191 | 1 | |
| 116.6676807 | 1 |
Time_of_Day
Categorical
Missing
| Distinct | 4 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 50 |
| Missing (%) | 5.0% |
| Memory size | 7.9 KiB |
| Afternoon | |
|---|---|
| Morning | |
| Evening | |
| Night |
Length
| Max length | 9 |
|---|---|
| Median length | 7 |
| Mean length | 7.5852632 |
| Min length | 5 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Morning |
|---|---|
| 2nd row | Afternoon |
| 3rd row | Evening |
| 4th row | Evening |
| 5th row | Evening |
Common Values
| Value | Count | Frequency (%) |
| Afternoon | 371 | |
| Morning | 283 | |
| Evening | 203 | |
| Night | 93 | 9.3% |
| (Missing) | 50 | 5.0% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| afternoon | 371 | |
| morning | 283 | |
| evening | 203 | |
| night | 93 | 9.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| n | 1714 | |
| o | 1025 | |
| r | 654 | 9.1% |
| i | 579 | 8.0% |
| g | 579 | 8.0% |
| e | 574 | 8.0% |
| t | 464 | 6.4% |
| A | 371 | 5.1% |
| f | 371 | 5.1% |
| M | 283 | 3.9% |
| Other values (4) | 592 | 8.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 7206 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| n | 1714 | |
| o | 1025 | |
| r | 654 | 9.1% |
| i | 579 | 8.0% |
| g | 579 | 8.0% |
| e | 574 | 8.0% |
| t | 464 | 6.4% |
| A | 371 | 5.1% |
| f | 371 | 5.1% |
| M | 283 | 3.9% |
| Other values (4) | 592 | 8.2% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 7206 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| n | 1714 | |
| o | 1025 | |
| r | 654 | 9.1% |
| i | 579 | 8.0% |
| g | 579 | 8.0% |
| e | 574 | 8.0% |
| t | 464 | 6.4% |
| A | 371 | 5.1% |
| f | 371 | 5.1% |
| M | 283 | 3.9% |
| Other values (4) | 592 | 8.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 7206 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| n | 1714 | |
| o | 1025 | |
| r | 654 | 9.1% |
| i | 579 | 8.0% |
| g | 579 | 8.0% |
| e | 574 | 8.0% |
| t | 464 | 6.4% |
| A | 371 | 5.1% |
| f | 371 | 5.1% |
| M | 283 | 3.9% |
| Other values (4) | 592 | 8.2% |
Day_of_Week
Categorical
Missing
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 50 |
| Missing (%) | 5.0% |
| Memory size | 7.9 KiB |
| Weekday | |
|---|---|
| Weekend |
Length
| Max length | 7 |
|---|---|
| Median length | 7 |
| Mean length | 7 |
| Min length | 7 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Weekday |
|---|---|
| 2nd row | Weekday |
| 3rd row | Weekend |
| 4th row | Weekday |
| 5th row | Weekday |
Common Values
| Value | Count | Frequency (%) |
| Weekday | 655 | |
| Weekend | 295 | |
| (Missing) | 50 | 5.0% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| weekday | 655 | |
| weekend | 295 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 2195 | |
| W | 950 | |
| k | 950 | |
| d | 950 | |
| a | 655 | 9.8% |
| y | 655 | 9.8% |
| n | 295 | 4.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 6650 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 2195 | |
| W | 950 | |
| k | 950 | |
| d | 950 | |
| a | 655 | 9.8% |
| y | 655 | 9.8% |
| n | 295 | 4.4% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 6650 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 2195 | |
| W | 950 | |
| k | 950 | |
| d | 950 | |
| a | 655 | 9.8% |
| y | 655 | 9.8% |
| n | 295 | 4.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 6650 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 2195 | |
| W | 950 | |
| k | 950 | |
| d | 950 | |
| a | 655 | 9.8% |
| y | 655 | 9.8% |
| n | 295 | 4.4% |
Passenger_Count
Categorical
Missing
| Distinct | 4 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 50 |
| Missing (%) | 5.0% |
| Memory size | 7.9 KiB |
| 3.0 | |
|---|---|
| 2.0 | |
| 1.0 | |
| 4.0 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 3.0 |
|---|---|
| 2nd row | 1.0 |
| 3rd row | 1.0 |
| 4th row | 4.0 |
| 5th row | 3.0 |
Common Values
| Value | Count | Frequency (%) |
| 3.0 | 251 | |
| 2.0 | 241 | |
| 1.0 | 238 | |
| 4.0 | 220 | |
| (Missing) | 50 | 5.0% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 3.0 | 251 | |
| 2.0 | 241 | |
| 1.0 | 238 | |
| 4.0 | 220 |
Most occurring characters
| Value | Count | Frequency (%) |
| . | 950 | |
| 0 | 950 | |
| 3 | 251 | 8.8% |
| 2 | 241 | 8.5% |
| 1 | 238 | 8.4% |
| 4 | 220 | 7.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 2850 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| . | 950 | |
| 0 | 950 | |
| 3 | 251 | 8.8% |
| 2 | 241 | 8.5% |
| 1 | 238 | 8.4% |
| 4 | 220 | 7.7% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 2850 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| . | 950 | |
| 0 | 950 | |
| 3 | 251 | 8.8% |
| 2 | 241 | 8.5% |
| 1 | 238 | 8.4% |
| 4 | 220 | 7.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 2850 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| . | 950 | |
| 0 | 950 | |
| 3 | 251 | 8.8% |
| 2 | 241 | 8.5% |
| 1 | 238 | 8.4% |
| 4 | 220 | 7.7% |
Traffic_Conditions
Categorical
Missing
| Distinct | 3 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 50 |
| Missing (%) | 5.0% |
| Memory size | 7.9 KiB |
| Low | |
|---|---|
| Medium | |
| High |
Length
| Max length | 6 |
|---|---|
| Median length | 4 |
| Mean length | 4.3631579 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Low |
|---|---|
| 2nd row | High |
| 3rd row | High |
| 4th row | Low |
| 5th row | High |
Common Values
| Value | Count | Frequency (%) |
| Low | 397 | |
| Medium | 371 | |
| High | 182 | |
| (Missing) | 50 | 5.0% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| low | 397 | |
| medium | 371 | |
| high | 182 |
Most occurring characters
| Value | Count | Frequency (%) |
| i | 553 | |
| L | 397 | |
| o | 397 | |
| w | 397 | |
| M | 371 | |
| e | 371 | |
| d | 371 | |
| u | 371 | |
| m | 371 | |
| H | 182 | 4.4% |
| Other values (2) | 364 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 4145 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| i | 553 | |
| L | 397 | |
| o | 397 | |
| w | 397 | |
| M | 371 | |
| e | 371 | |
| d | 371 | |
| u | 371 | |
| m | 371 | |
| H | 182 | 4.4% |
| Other values (2) | 364 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 4145 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| i | 553 | |
| L | 397 | |
| o | 397 | |
| w | 397 | |
| M | 371 | |
| e | 371 | |
| d | 371 | |
| u | 371 | |
| m | 371 | |
| H | 182 | 4.4% |
| Other values (2) | 364 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 4145 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| i | 553 | |
| L | 397 | |
| o | 397 | |
| w | 397 | |
| M | 371 | |
| e | 371 | |
| d | 371 | |
| u | 371 | |
| m | 371 | |
| H | 182 | 4.4% |
| Other values (2) | 364 |
Weather
Categorical
Missing
| Distinct | 3 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 50 |
| Missing (%) | 5.0% |
| Memory size | 7.9 KiB |
| Clear | |
|---|---|
| Rain | |
| Snow | 56 |
Length
| Max length | 5 |
|---|---|
| Median length | 5 |
| Mean length | 4.7021053 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Clear |
|---|---|
| 2nd row | Clear |
| 3rd row | Clear |
| 4th row | Clear |
| 5th row | Clear |
Common Values
| Value | Count | Frequency (%) |
| Clear | 667 | |
| Rain | 227 | 22.7% |
| Snow | 56 | 5.6% |
| (Missing) | 50 | 5.0% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| clear | 667 | |
| rain | 227 | 23.9% |
| snow | 56 | 5.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 894 | |
| C | 667 | |
| l | 667 | |
| e | 667 | |
| r | 667 | |
| n | 283 | 6.3% |
| R | 227 | 5.1% |
| i | 227 | 5.1% |
| S | 56 | 1.3% |
| o | 56 | 1.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 4467 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 894 | |
| C | 667 | |
| l | 667 | |
| e | 667 | |
| r | 667 | |
| n | 283 | 6.3% |
| R | 227 | 5.1% |
| i | 227 | 5.1% |
| S | 56 | 1.3% |
| o | 56 | 1.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 4467 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 894 | |
| C | 667 | |
| l | 667 | |
| e | 667 | |
| r | 667 | |
| n | 283 | 6.3% |
| R | 227 | 5.1% |
| i | 227 | 5.1% |
| S | 56 | 1.3% |
| o | 56 | 1.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 4467 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 894 | |
| C | 667 | |
| l | 667 | |
| e | 667 | |
| r | 667 | |
| n | 283 | 6.3% |
| R | 227 | 5.1% |
| i | 227 | 5.1% |
| S | 56 | 1.3% |
| o | 56 | 1.3% |
Base_Fare
Real number (ℝ)
Missing
| Distinct | 290 |
|---|---|
| Distinct (%) | 30.5% |
| Missing | 50 |
| Missing (%) | 5.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.5029895 |
| Minimum | 2.01 |
|---|---|
| Maximum | 5 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 7.9 KiB |
Quantile statistics
| Minimum | 2.01 |
|---|---|
| 5-th percentile | 2.1645 |
| Q1 | 2.73 |
| median | 3.52 |
| Q3 | 4.26 |
| 95-th percentile | 4.85 |
| Maximum | 5 |
| Range | 2.99 |
| Interquartile range (IQR) | 1.53 |
Descriptive statistics
| Standard deviation | 0.87016193 |
|---|---|
| Coefficient of variation (CV) | 0.24840552 |
| Kurtosis | -1.2132238 |
| Mean | 3.5029895 |
| Median Absolute Deviation (MAD) | 0.76 |
| Skewness | -0.0051492734 |
| Sum | 3327.84 |
| Variance | 0.75718178 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 3.94 | 10 | 1.0% |
| 3.88 | 8 | 0.8% |
| 2.8 | 8 | 0.8% |
| 2.32 | 8 | 0.8% |
| 3.89 | 7 | 0.7% |
| 4.6 | 7 | 0.7% |
| 2.17 | 7 | 0.7% |
| 3.13 | 7 | 0.7% |
| 2.38 | 7 | 0.7% |
| 2.43 | 7 | 0.7% |
| Other values (280) | 874 | |
| (Missing) | 50 | 5.0% |
| Value | Count | Frequency (%) |
| 2.01 | 1 | 0.1% |
| 2.02 | 3 | |
| 2.03 | 2 | 0.2% |
| 2.04 | 2 | 0.2% |
| 2.05 | 5 | |
| 2.06 | 4 | |
| 2.07 | 2 | 0.2% |
| 2.08 | 4 | |
| 2.09 | 1 | 0.1% |
| 2.1 | 3 |
| Value | Count | Frequency (%) |
| 5 | 2 | 0.2% |
| 4.99 | 4 | |
| 4.97 | 4 | |
| 4.96 | 5 | |
| 4.95 | 3 | |
| 4.94 | 5 | |
| 4.93 | 3 | |
| 4.92 | 3 | |
| 4.91 | 3 | |
| 4.9 | 7 |
Per_Km_Rate
Real number (ℝ)
Missing
| Distinct | 150 |
|---|---|
| Distinct (%) | 15.8% |
| Missing | 50 |
| Missing (%) | 5.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.2333158 |
| Minimum | 0.5 |
|---|---|
| Maximum | 2 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 7.9 KiB |
Quantile statistics
| Minimum | 0.5 |
|---|---|
| 5-th percentile | 0.5845 |
| Q1 | 0.86 |
| median | 1.22 |
| Q3 | 1.61 |
| 95-th percentile | 1.91 |
| Maximum | 2 |
| Range | 1.5 |
| Interquartile range (IQR) | 0.75 |
Descriptive statistics
| Standard deviation | 0.42981587 |
|---|---|
| Coefficient of variation (CV) | 0.34850431 |
| Kurtosis | -1.1986632 |
| Mean | 1.2333158 |
| Median Absolute Deviation (MAD) | 0.37 |
| Skewness | 0.079206429 |
| Sum | 1171.65 |
| Variance | 0.18474168 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0.63 | 15 | 1.5% |
| 1.5 | 13 | 1.3% |
| 1.9 | 12 | 1.2% |
| 1.92 | 12 | 1.2% |
| 0.79 | 12 | 1.2% |
| 1.71 | 12 | 1.2% |
| 0.7 | 11 | 1.1% |
| 1.3 | 11 | 1.1% |
| 1.86 | 11 | 1.1% |
| 0.82 | 11 | 1.1% |
| Other values (140) | 830 | |
| (Missing) | 50 | 5.0% |
| Value | Count | Frequency (%) |
| 0.5 | 2 | 0.2% |
| 0.51 | 9 | |
| 0.52 | 2 | 0.2% |
| 0.53 | 5 | |
| 0.54 | 3 | 0.3% |
| 0.55 | 4 | |
| 0.56 | 9 | |
| 0.57 | 8 | |
| 0.58 | 6 | |
| 0.59 | 4 |
| Value | Count | Frequency (%) |
| 2 | 2 | 0.2% |
| 1.99 | 2 | 0.2% |
| 1.98 | 5 | |
| 1.97 | 3 | 0.3% |
| 1.96 | 4 | 0.4% |
| 1.95 | 5 | |
| 1.94 | 8 | |
| 1.93 | 3 | 0.3% |
| 1.92 | 12 | |
| 1.91 | 8 |
Per_Minute_Rate
Real number (ℝ)
Missing
| Distinct | 41 |
|---|---|
| Distinct (%) | 4.3% |
| Missing | 50 |
| Missing (%) | 5.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.29291579 |
| Minimum | 0.1 |
|---|---|
| Maximum | 0.5 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 7.9 KiB |
Quantile statistics
| Minimum | 0.1 |
|---|---|
| 5-th percentile | 0.12 |
| Q1 | 0.19 |
| median | 0.29 |
| Q3 | 0.39 |
| 95-th percentile | 0.48 |
| Maximum | 0.5 |
| Range | 0.4 |
| Interquartile range (IQR) | 0.2 |
Descriptive statistics
| Standard deviation | 0.11559177 |
|---|---|
| Coefficient of variation (CV) | 0.39462458 |
| Kurtosis | -1.1992318 |
| Mean | 0.29291579 |
| Median Absolute Deviation (MAD) | 0.1 |
| Skewness | 0.058695065 |
| Sum | 278.27 |
| Variance | 0.013361458 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=41)
| Value | Count | Frequency (%) |
| 0.15 | 35 | 3.5% |
| 0.28 | 33 | 3.3% |
| 0.18 | 32 | 3.2% |
| 0.38 | 31 | 3.1% |
| 0.23 | 30 | 3.0% |
| 0.12 | 30 | 3.0% |
| 0.42 | 27 | 2.7% |
| 0.31 | 27 | 2.7% |
| 0.2 | 27 | 2.7% |
| 0.11 | 26 | 2.6% |
| Other values (31) | 652 | |
| (Missing) | 50 | 5.0% |
| Value | Count | Frequency (%) |
| 0.1 | 14 | 1.4% |
| 0.11 | 26 | |
| 0.12 | 30 | |
| 0.13 | 21 | |
| 0.14 | 22 | |
| 0.15 | 35 | |
| 0.16 | 21 | |
| 0.17 | 24 | |
| 0.18 | 32 | |
| 0.19 | 25 |
| Value | Count | Frequency (%) |
| 0.5 | 9 | 0.9% |
| 0.49 | 24 | |
| 0.48 | 21 | |
| 0.47 | 20 | |
| 0.46 | 21 | |
| 0.45 | 21 | |
| 0.44 | 21 | |
| 0.43 | 21 | |
| 0.42 | 27 | |
| 0.41 | 19 |
Trip_Duration_Minutes
Real number (ℝ)
Missing
| Distinct | 917 |
|---|---|
| Distinct (%) | 96.5% |
| Missing | 50 |
| Missing (%) | 5.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 62.118116 |
| Minimum | 5.01 |
|---|---|
| Maximum | 119.84 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 7.9 KiB |
Quantile statistics
| Minimum | 5.01 |
|---|---|
| 5-th percentile | 11.4025 |
| Q1 | 35.8825 |
| median | 61.86 |
| Q3 | 89.055 |
| 95-th percentile | 112.7815 |
| Maximum | 119.84 |
| Range | 114.83 |
| Interquartile range (IQR) | 53.1725 |
Descriptive statistics
| Standard deviation | 32.154406 |
|---|---|
| Coefficient of variation (CV) | 0.51763332 |
| Kurtosis | -1.1228564 |
| Mean | 62.118116 |
| Median Absolute Deviation (MAD) | 26.44 |
| Skewness | 0.017749129 |
| Sum | 59012.21 |
| Variance | 1033.9059 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 89.21 | 3 | 0.3% |
| 113.49 | 2 | 0.2% |
| 94.11 | 2 | 0.2% |
| 30.31 | 2 | 0.2% |
| 65.42 | 2 | 0.2% |
| 84 | 2 | 0.2% |
| 107.25 | 2 | 0.2% |
| 109.53 | 2 | 0.2% |
| 44.99 | 2 | 0.2% |
| 59.81 | 2 | 0.2% |
| Other values (907) | 929 | |
| (Missing) | 50 | 5.0% |
| Value | Count | Frequency (%) |
| 5.01 | 1 | |
| 5.05 | 1 | |
| 5.1 | 1 | |
| 5.5 | 1 | |
| 5.61 | 1 | |
| 5.65 | 1 | |
| 5.66 | 1 | |
| 5.93 | 1 | |
| 6.06 | 2 | |
| 6.1 | 1 |
| Value | Count | Frequency (%) |
| 119.84 | 1 | |
| 119.82 | 1 | |
| 119.65 | 1 | |
| 119.54 | 1 | |
| 119.21 | 1 | |
| 119.17 | 1 | |
| 119.08 | 1 | |
| 118.44 | 1 | |
| 118.39 | 1 | |
| 117.94 | 1 |
Trip_Price
Real number (ℝ)
High correlation Missing
| Distinct | 951 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 49 |
| Missing (%) | 4.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 56.874773 |
| Minimum | 6.1269 |
|---|---|
| Maximum | 332.04369 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 7.9 KiB |
Quantile statistics
| Minimum | 6.1269 |
|---|---|
| 5-th percentile | 18.8131 |
| Q1 | 33.74265 |
| median | 50.0745 |
| Q3 | 69.09935 |
| 95-th percentile | 102.3809 |
| Maximum | 332.04369 |
| Range | 325.91679 |
| Interquartile range (IQR) | 35.3567 |
Descriptive statistics
| Standard deviation | 40.469791 |
|---|---|
| Coefficient of variation (CV) | 0.71155959 |
| Kurtosis | 19.892281 |
| Mean | 56.874773 |
| Median Absolute Deviation (MAD) | 17.167 |
| Skewness | 3.7325606 |
| Sum | 54087.909 |
| Variance | 1637.8039 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 86.3545 | 1 | 0.1% |
| 65.195 | 1 | 0.1% |
| 85.4652 | 1 | 0.1% |
| 69.9148 | 1 | 0.1% |
| 72.1607 | 1 | 0.1% |
| 36.4212 | 1 | 0.1% |
| 41.0143 | 1 | 0.1% |
| 33.2317 | 1 | 0.1% |
| 38.9635 | 1 | 0.1% |
| 24.6913 | 1 | 0.1% |
| Other values (941) | 941 | |
| (Missing) | 49 | 4.9% |
| Value | Count | Frequency (%) |
| 6.1269 | 1 | |
| 6.4729 | 1 | |
| 8.6709 | 1 | |
| 8.7296 | 1 | |
| 8.9203 | 1 | |
| 9.8005 | 1 | |
| 9.8718 | 1 | |
| 9.9494 | 1 | |
| 10.2366 | 1 | |
| 10.4444 | 1 |
| Value | Count | Frequency (%) |
| 332.0436887 | 1 | |
| 329.9130039 | 1 | |
| 328.8717691 | 1 | |
| 327.2176655 | 1 | |
| 325.0989498 | 1 | |
| 322.7259961 | 1 | |
| 320.9586636 | 1 | |
| 296.0886973 | 1 | |
| 283.6452006 | 1 | |
| 280.8773016 | 1 |
Interactions
Correlations
| Base_Fare | Day_of_Week | Passenger_Count | Per_Km_Rate | Per_Minute_Rate | Time_of_Day | Traffic_Conditions | Trip_Distance_km | Trip_Duration_Minutes | Trip_Price | Weather | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Base_Fare | 1.000 | 0.000 | 0.000 | 0.001 | -0.018 | 0.000 | 0.044 | 0.045 | 0.013 | 0.046 | 0.077 |
| Day_of_Week | 0.000 | 1.000 | 0.000 | 0.000 | 0.049 | 0.045 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |
| Passenger_Count | 0.000 | 0.000 | 1.000 | 0.000 | 0.000 | 0.000 | 0.030 | 0.028 | 0.000 | 0.000 | 0.040 |
| Per_Km_Rate | 0.001 | 0.000 | 0.000 | 1.000 | 0.032 | 0.020 | 0.000 | -0.035 | 0.027 | 0.389 | 0.011 |
| Per_Minute_Rate | -0.018 | 0.049 | 0.000 | 0.032 | 1.000 | 0.042 | 0.079 | -0.021 | -0.026 | 0.265 | 0.000 |
| Time_of_Day | 0.000 | 0.045 | 0.000 | 0.020 | 0.042 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |
| Traffic_Conditions | 0.044 | 0.000 | 0.030 | 0.000 | 0.079 | 0.000 | 1.000 | 0.044 | 0.000 | 0.086 | 0.000 |
| Trip_Distance_km | 0.045 | 0.000 | 0.028 | -0.035 | -0.021 | 0.000 | 0.044 | 1.000 | -0.036 | 0.722 | 0.006 |
| Trip_Duration_Minutes | 0.013 | 0.000 | 0.000 | 0.027 | -0.026 | 0.000 | 0.000 | -0.036 | 1.000 | 0.348 | 0.000 |
| Trip_Price | 0.046 | 0.000 | 0.000 | 0.389 | 0.265 | 0.000 | 0.086 | 0.722 | 0.348 | 1.000 | 0.000 |
| Weather | 0.077 | 0.000 | 0.040 | 0.011 | 0.000 | 0.000 | 0.000 | 0.006 | 0.000 | 0.000 | 1.000 |
Missing values
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.
Sample
| Trip_Distance_km | Time_of_Day | Day_of_Week | Passenger_Count | Traffic_Conditions | Weather | Base_Fare | Per_Km_Rate | Per_Minute_Rate | Trip_Duration_Minutes | Trip_Price | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 19.35 | Morning | Weekday | 3.0 | Low | Clear | 3.56 | 0.80 | 0.32 | 53.82 | 36.2624 |
| 1 | 47.59 | Afternoon | Weekday | 1.0 | High | Clear | NaN | 0.62 | 0.43 | 40.57 | NaN |
| 2 | 36.87 | Evening | Weekend | 1.0 | High | Clear | 2.70 | 1.21 | 0.15 | 37.27 | 52.9032 |
| 3 | 30.33 | Evening | Weekday | 4.0 | Low | NaN | 3.48 | 0.51 | 0.15 | 116.81 | 36.4698 |
| 4 | NaN | Evening | Weekday | 3.0 | High | Clear | 2.93 | 0.63 | 0.32 | 22.64 | 15.6180 |
| 5 | 8.64 | Afternoon | Weekend | 2.0 | Medium | Clear | 2.55 | 1.71 | 0.48 | 89.33 | 60.2028 |
| 6 | 3.85 | Afternoon | Weekday | 4.0 | High | Rain | 3.51 | 1.66 | NaN | 5.05 | 11.2645 |
| 7 | 43.44 | Evening | Weekend | 3.0 | NaN | Clear | 2.97 | 1.87 | 0.23 | NaN | 101.1216 |
| 8 | 30.45 | Morning | Weekday | 3.0 | High | Clear | 2.77 | 1.78 | 0.34 | 110.33 | NaN |
| 9 | 35.70 | Afternoon | Weekday | 2.0 | Low | Rain | 3.39 | 1.52 | 0.47 | NaN | 75.5657 |
| Trip_Distance_km | Time_of_Day | Day_of_Week | Passenger_Count | Traffic_Conditions | Weather | Base_Fare | Per_Km_Rate | Per_Minute_Rate | Trip_Duration_Minutes | Trip_Price | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 990 | 40.17 | Evening | Weekday | 3.0 | Low | Clear | 3.81 | 0.66 | 0.42 | 62.66 | 56.6394 |
| 991 | 35.04 | Morning | Weekend | 4.0 | Medium | Rain | 2.90 | 1.10 | 0.15 | 9.99 | NaN |
| 992 | 14.34 | Afternoon | Weekday | 1.0 | Medium | Clear | 3.23 | 1.01 | 0.29 | 45.07 | 30.7837 |
| 993 | NaN | Morning | Weekday | 3.0 | Medium | Clear | 2.65 | 1.35 | NaN | 25.61 | 55.3348 |
| 994 | 18.69 | Evening | Weekday | 3.0 | Medium | Clear | 4.90 | 1.79 | 0.17 | 79.41 | 51.8548 |
| 995 | 5.49 | Afternoon | Weekend | 4.0 | Medium | Clear | 2.39 | 0.62 | 0.49 | 58.39 | 34.4049 |
| 996 | 45.95 | Night | Weekday | 4.0 | Medium | Clear | 3.12 | 0.61 | NaN | 61.96 | 62.1295 |
| 997 | 7.70 | Morning | Weekday | 3.0 | Low | Rain | 2.08 | 1.78 | NaN | 54.18 | 33.1236 |
| 998 | 47.56 | Morning | Weekday | 1.0 | Low | Clear | 2.67 | 0.82 | 0.17 | 114.94 | 61.2090 |
| 999 | 22.85 | Morning | Weekend | 3.0 | Medium | Clear | 4.34 | NaN | 0.23 | 29.69 | 45.4437 |